The job definition feed contains the definition of a SQL Server job including the job's steps. The step name is used as the feed title. The following information is reported for each step:
- Command type: Type of command such as T-SQL, ActiveX, PowerShell, CmdExec etc.
- Command: The actual command executed on this step of the job.
- On success: Action that will be invoked upon successful completion of this step.
- On success go to the step: The step that will be executed upon successful completion of this step.
- On failure: Action that will be invoked upon failure of this step.
- On failure go to the step: The step that will be executed upon failure of this step.
- Database: Database against which this step will be executed.
- Run as: The proxy account that will be used for this step of the job.
- Retry attempts: Number of times this step will be retried in case of failure.
- Retry interval (minutes): The time interval in minutes between retry attempts.
- Output file: The file to use for output from this job step.
- Last executed on: The date and time of the last execution.
- Status of the last run: Indicates whether the step succeeded, failed, or is still running.
- Number of times executed: Number of times this step has been executed.
- Min. duration: The shortest time it took the step to complete out of all executions.
- Max. duration: The longest time it took the step to complete out of all executions.
- Avg. duration: The average time it takes the step to complete.
 |
You can customize the feed via the web.config parameter JobDefinitionFeed. |
